<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE topic
  PUBLIC "-//OASIS//DTD DITA Composite//EN" "ditabase.dtd">
<topic id="topic1" xml:lang="en">
  <title id="fs142834">foreign_tables</title>
  <body>
    <p>The <codeph>foreign_tables</codeph> view contains all foreign tables defined
      in the current database. Greenplum Database displays only those foreign tables to
       which the current user has access (by way of being the owner or having some privilege).</p>
    <table id="fs142842">
      <title>foreign_tables</title>
      <tgroup cols="4">
        <colspec colnum="1" colname="col1" colwidth="131pt"/>
        <colspec colnum="2" colname="col2" colwidth="73pt"/>
        <colspec colnum="3" colname="col3" colwidth="101pt"/>
        <colspec colnum="4" colname="col4" colwidth="145pt"/>
        <thead>
          <row>
            <entry colname="col1">column</entry>
            <entry colname="col2">type</entry>
            <entry colname="col3">references</entry>
            <entry colname="col4">description</entry>
          </row>
        </thead>
        <tbody>
          <row>
            <entry colname="col1">
              <codeph>foreign_table_catalog</codeph>
            </entry>
            <entry colname="col2">sql_identifier</entry>
            <entry colname="col3"></entry>
            <entry colname="col4">Name of the database in which the foreign table
              is defined (always the current database).</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>foreign_table_schema</codeph>
            </entry>
            <entry colname="col2">sql_identifier</entry>
            <entry colname="col3"></entry>
            <entry colname="col4">Name of the schema that contains the foreign table.</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>foreign_table_name</codeph>
            </entry>
            <entry colname="col2">sql_identifier</entry>
            <entry colname="col3"></entry>
            <entry colname="col4">Name of the foreign table.</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>foreign_server_catalog</codeph>
            </entry>
            <entry colname="col2">sql_identifier</entry>
            <entry colname="col3"></entry>
            <entry colname="col4">Name of the database in which the foreign server
              is defined (always the current database).</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>foreign_server_name</codeph>
            </entry>
            <entry colname="col2">sql_identifier</entry>
            <entry colname="col3"></entry>
            <entry colname="col4">Name of the foreign server.</entry>
          </row>
        </tbody>
      </tgroup>
    </table>
  </body>
</topic>
